SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwrDivisionesSF
AS
SELECT     idDivision AS ID, Mnemo AS Descripcion, Mnemo, Curso, Division
FROM         dbo.tb_Divisiones
GO
GRANT SELECT ON  [dbo].[vwrDivisionesSF] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vwrDivisionesSF] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vwrDivisionesSF] TO [Direcciones De Nivel]
GRANT SELECT ON  [dbo].[vwrDivisionesSF] TO [GestionInstitucional]
GRANT SELECT ON  [dbo].[vwrDivisionesSF] TO [Juntas]
GRANT SELECT ON  [dbo].[vwrDivisionesSF] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vwrDivisionesSF] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vwrDivisionesSF] TO [SoloVer]
GO
